2014-09-11 - 14160.100 - Rel Notes - HANA Sizing - Release 002 #BIReleases2014

Release Notes

14160.100 - Hana Sizing - BPQ

Admin Info



Purpose
Need to Delete PSA tables and do compression on cubes and to run scripts to get HANA expected sizing in BPQ.
Release No
002
Submitted on
09/11/2014
Submitted by
Uday Kumar P
Environment
BW Quality(BPQ)
Sent To
Mark Harris
Transport Status
NA

Transport and Technical Objects


None

Release Notes


For Requestor

1. Parameters for BW HANA Sizing Program:

BPQ - Parameters.jpg

2. Sizing Recommendation For BPQ (Before deletion of PSA tables and Change Log Tables):

Parameters/Estimates
Value
Minimum total memory requirement
428 GB
Time considered for growth
3 Years
Assumed yearly growth rate
33.0 %
Estimated size after 1 year(s)
552 GB
Estimated size after 2 year(s)
718 GB
Estimated size after 3 year(s)
938 GB

The Hana Sizing Output in BPQ before deletion of PSA Tables and Change log Tables is shown in the attached HTML document:
HANA Sizing(Before Deletion of PSA & Change log Tables) - BPQ.htm

Summary of the HANA Sizing Program Output:
BPq.JPG

3. Sizing Recommendation For BPQ (After deletion of PSA tables and Change Log Tables):


Parameters/Estimates
Value
Minimum total memory requirement
102 GB
Time considered for growth
3 Years
Assumed yearly growth rate
33.0 %
Estimated size after 1 year(s)
120 GB
Estimated size after 2 year(s)
143 GB
Estimated size after 3 year(s)
174 GB

The Hana Sizing Output in BPQ after deletion of PSA Tables and Change log Tables is the shown in attached HTML document:
HANA Sizing(After Deletion of PSA & Change log Tables) - BPQ.htm

Summary of the HANA Sizing Program Output:
BPq2.JPG

Reference Document(Specification)

2014-09-02 - 14160.100 - Spec - HANA Sizing
2014-09-11 - 14160.100 - Rel Notes - HANA Sizing - Release 001